Jon Mark H ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	16

About Me

About Me

Area of Expertise	Formulas & Automation
How I Use Smartsheet	Project Management

Analytics

92

Posts

133

Visits

762

Points

Mar 15, 2022

Join Date

Jan 8, 2025

Last Active

Reactions

• Insightful 4

  4
• Vote Up 7

  7
• Awesome 3

  3

• Activity
• Discussions
• Comments92

• Re: Connect several columns from data sheet to another sheet

  Jon Mark H

  04/30/22
  Hey Chris! Can you detail a little bit more what you're trying to do: 1.) Are you using every single row from your large Data sheet in the new/more slim sheet, or just specific rows? 2.) Is there som…
  1 ·

• Re: Countifs formula looks at two columns, multi items in one of the columns

  Jon Mark H

  04/06/22
  So close @NCharleb ! It's a little funky how it works. You want to go with: =COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, OR(@cell = "Open", @ce…
  1 ·

• Re: Multiple nesting help!

  Jon Mark H

  04/06/22
  Hey @Loghen.Christyne ! It looks like this should get that column showing properly: If Delivery Timeliness is blank - it will just show a 0 in this column =COUNTIFS([Delivery Timeliness]:[Delivery Ti…
  1 ·

• Re: Super Simple: need to reference a date from one cell to another

  Jon Mark H

  03/29/22
  Hey Pamela! The formula should be: =Start@row - this will pull the Date from the Start date row (assuming it's called "Start" & that your "Actual Start" column is also formatt…
  1 ·